--------------------------------------------------------
--  DDL for Trigger CA_TGR_BLACK_LIST
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_BLACK_LIST" 
　　
  before insert on ca_black_list
  
  for each row
  
  begin
  
  select SYSTEM.CA_SEQ_BLACK_LIST.nextval into :new.REC_ID from dual;

end CA_TGR_BLACK_LIST;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_BLACK_LIST" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_CART
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_CART" 
　　
    before insert on CA_CART
    
    for each row
    
    begin
    
    select CA_SEQ_CART.nextval into :new.REC_ID from dual;
    
    end CA_TGR_CART;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_CART" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_CLIENT_ACTION_LOG
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_CLIENT_ACTION_LOG" 
　　
    before insert on COMMON_USER_ACTION_LOG
    
    for each row
    
    begin
    
    select SEQ_USERACTION.nextval into :new.RECORD_ID from dual;
    
    end CA_TGR_CLIENT_ACTION_LOG;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_CLIENT_ACTION_LOG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_COMMON_USER
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_COMMON_USER" 
　　
    before insert on CA_MOBILE_LOG
    
    for each row
    
    begin
    
    select CA_SEQ_MOBILE_LOG.nextval into :new.LOG_ID from dual;
    
    end CA_TGR_COMMON_USER;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_COMMON_USER" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_DB_ANAL
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_DB_ANAL" 
　　
    before insert on CA_RUNTIME_ANAL
    
    for each row
    
    begin
    
    select CA_SEQ_DB_ANAL.nextval into :new.RECORD_ID from dual;
    
    end CA_TGR_DB_ANAL;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_DB_ANAL" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_DETAIL_FOOD
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_DETAIL_FOOD" 
　　
    before insert on CA_DETAIL_FOOD
    
    for each row
    
    begin
    
    select CA_SEQ_FOOD_DETAIL.nextval into :new.RECORD_ID from dual;
    
    end CA_TGR_DETAIL_FOOD;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_DETAIL_FOOD" DISABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_FAV
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_FAV" 
　　
    before insert on COMMON_USER_FAV
    
    for each row
    
    begin
    
    select CA_SEQ_FAV.nextval into :new.FAVID from dual;
    
    end COMMON_USER_FAV;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_FAV" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_FOOD_CATEGORY
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_FOOD_CATEGORY" 
　　
    before insert on CA_FOOD_CATEGORY
    
    for each row
    
    begin
    
    select CA_SEQ_FOOD_CATEGORY.nextval into :new.CATEGORY_ID from dual;
    
    end CA_TGR_FOOD_CATEGORY;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_FOOD_CATEGORY" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_FOOD_COMMENT
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_FOOD_COMMENT" 
　　
    before insert on CA_FOOD_COMMENT
    
    for each row
    
    begin
    
    select CA_SEQ_FOOD_COMMENT.nextval into :new.RECORD_ID from dual;
    
    end CA_TGR_FOOD_COMMENT;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_FOOD_COMMENT" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_FOOD_MERCHANT
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_FOOD_MERCHANT" 
　　
    before insert on CA_MERCHANT
    
    for each row
    
    begin
    
    select CA_SEQ_MERCHANT.nextval into :new.RECORD_ID from dual;
    
    end CA_TGR_FOOD_MERCHANT;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_FOOD_MERCHANT" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_FOOD_TYPE
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_FOOD_TYPE" 
　　
    before insert on CA_FOOD_TYPE
    
    for each row
    
    begin
    
    select CA_SEQ_FOOD_TYPE.nextval into :new.TYPE_ID from dual;
    
    end CA_TGR_FOOD_TYPE;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_FOOD_TYPE" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_LESSON
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_LESSON" 　　 before
  INSERT ON MOBILE_LESSON FOR EACH row BEGIN
  SELECT seq_lesson_id.nextval INTO :new."ID" FROM dual;
END CA_TGR_LESSON;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_LESSON" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_MESSAGES
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_MESSAGES" 
　　
    before insert on CA_MESSAGES
    
    for each row
    
    begin
    
    select CA_SEQ_MESSAGES.nextval into :new.REC_ID from dual;
    
    end CA_TGR_MESSAGES;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_MESSAGES" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_NETWORK_PROCESS
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_NETWORK_PROCESS" 
　　
    before insert on ca_network_process
    
    for each row
    
    begin
    
    select CA_SEQ_NETWORK_PROCESS.nextval into :new.REC_ID from dual;
    
    end CA_TGR_NETWORK_PROCESS;
    
/
ALTER TRIGGER "SYSTEM"."CA_TGR_NETWORK_PROCESS" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_OP_CODE
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_OP_CODE" 
　　
    before insert on CA_OP_LOG
    
    for each row
    
    begin
    
    select SEQ_OP_LOG.nextval into :new.RECORD_ID from dual;
    
    end CA_TGR_OP_CODE;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_OP_CODE" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_ORDER_GOODS
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_ORDER_GOODS" 
　　
    before insert on CA_ORDER_GOODS
    
    for each row
    
    begin
    
    select CA_SEQ_ORDER_GOODS.nextval into :new.REC_ID from dual;
    
    end CA_TGR_ORDER_GOODS;
    
/
ALTER TRIGGER "SYSTEM"."CA_TGR_ORDER_GOODS" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_ORDER_INFO
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_ORDER_INFO" 
　　
    before insert on CA_ORDER_INFO
    
    for each row
    
    begin
    
    select CA_SEQ_ORDER_INFO.nextval into :new.ORDER_ID from dual;
    
    end CA_TGR_ORDER_INFO;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_ORDER_INFO" DISABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_PKB
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_PKB" 　　 before
  INSERT ON MOBILE_PKB FOR EACH row BEGIN
  SELECT seq_pkb_id.nextval INTO :new."ID" FROM dual;
END CA_TGR_PKB;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_PKB" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_PLAY
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_PLAY" 
　　
    before insert on CA_PLAY
    
    for each row
    
    begin
    
    select SEQ_PLAY.nextval into :new.RECORD_ID from dual;
    
   end CA_TGR_PLAY;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_PLAY" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_PLAY_COMMENT
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_PLAY_COMMENT" 
　　
    before insert on CA_PLAY_COMMENT
    
    for each row
    
    begin
    
    select SEQ_PLAYCOMMENT.nextval into :new.RECORD_ID from dual;
    
   end CA_TGR_PLAY_COMMENT;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_PLAY_COMMENT" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_SENSITIVE
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_SENSITIVE" 
　　
    before insert on CA_SENSITIVE
    
    for each row
    
    begin
    
    select SEQ_SENSITIVE.nextval into :new.RECORD_ID from dual;
    
    end CA_TGR_CLIENT_ACTION_LOG;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_SENSITIVE" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_SIMPLE_FOOD
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_SIMPLE_FOOD" 
　　
    before insert on CA_SIMPLE_FOOD
    
    for each row
    
    begin
    
    select CA_SEQ_SIMPLE_FOOD.nextval into :new.RECORD_ID from dual;
    
    end CA_TGR_SIMPLE_FOOD;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_SIMPLE_FOOD" DISABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_SKB
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_SKB" 　　 before
  INSERT ON MOBILE_SKB FOR EACH row BEGIN
  SELECT seq_skb_id.nextval INTO :new."SKB_ID" FROM dual;
END CA_TGR_SKB;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_SKB" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_TEACHER
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_TEACHER" 　　 before
  INSERT ON MOBILE_TEACHER FOR EACH row BEGIN
  SELECT SEQ_TEACHER_ID.nextval INTO :new."RECORD_ID" FROM dual;
END CA_TGR_TEACHER;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_TEACHER" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_TRANS_GRADE
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_TRANS_GRADE" 
　　
    before insert on MOBILE_GRADE
    
    for each row
    
    begin
    
    select seq_grade_id.nextval into :new."ID" from dual;
    
    end CA_TGR_TRANS_GRADE;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_TRANS_GRADE" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_TGR_T_SKB
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_TGR_T_SKB" 　　 before
  INSERT ON MOBILE_T_SKB FOR EACH row BEGIN
  SELECT SEQ_T_SKB_ID.nextval INTO :new."RECORD_ID" FROM dual;
END CA_TGR_T_SKB;
/
ALTER TRIGGER "SYSTEM"."CA_TGR_T_SKB" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CA_WEB_TGR_DATATRANS
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."CA_WEB_TGR_DATATRANS" 
　　
    before insert on CA_DATATRANS
    
    for each row
    
    begin
    
    select SEQ_DATATRANS.nextval into :new.RECORD_ID from dual;
    
    end CA_WEB_TGR_DATATRANS;
/
ALTER TRIGGER "SYSTEM"."CA_WEB_TGR_DATATRANS" ENABLE;
--------------------------------------------------------
--  DDL for Trigger DEF$_PROPAGATOR_TRIG
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."DEF$_PROPAGATOR_TRIG" 
  BEFORE INSERT ON system.def$_propagator
DECLARE
  prop_count  NUMBER;
BEGIN
  SELECT count(*) into prop_count
    FROM system.def$_propagator;

  IF (prop_count > 0) THEN
    -- Raise duplicate propagator error
    sys.dbms_sys_error.raise_system_error(-23394);
  END IF;
END;
/
ALTER TRIGGER "SYSTEM"."DEF$_PROPAGATOR_TRIG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger REPCATLOGTRIG
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."REPCATLOGTRIG" 
AFTER UPDATE OR DELETE ON system.repcat$_repcatlog
BEGIN
  sys.dbms_alert.signal('repcatlog_alert', '');
END;
/
ALTER TRIGGER "SYSTEM"."REPCATLOGTRIG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_ACTIVITY_ID
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_ACTIVITY_ID" 
　　
    before insert on COMMON_ACTIVITY
    
    for each row
    
    begin
    
    select SEQ_ACTIVTTY_ID.nextval into :new.RECORD_ID from dual;
    
    end TGR_ACTIVITY_ID;
/
ALTER TRIGGER "SYSTEM"."TGR_ACTIVITY_ID" DISABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_ADVERTISMENT_INSERT_ID
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_ADVERTISMENT_INSERT_ID" 
before insert on MOBILE_ADVERTISMENT
for each row
begin
  select SEQ_ADVERTISMENT_ID.nextval into :new.ADVID from dual;
end tgr_advertisment_insert_id;
/
ALTER TRIGGER "SYSTEM"."TGR_ADVERTISMENT_INSERT_ID" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_APP_PUB
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_APP_PUB" 
BEFORE INSERT ON COMMON_APP_PUB 
FOR EACH ROW
BEGIN
  SELECT SEQ_APP_PUB.NEXTVAL INTO :NEW."ID" FROM DUAL;
END;
/
ALTER TRIGGER "SYSTEM"."TGR_APP_PUB" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_COMMON_ENTERTAINMENT
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_COMMON_ENTERTAINMENT" 
　　
    before insert on COMMON_ENTERTAINMENT
    
    for each row
    
    begin
    
    select SEQ_ENTERTAINMENT_ID.nextval into :new.RECORD_ID from dual;
    
   end TGR_COMMON_ENTERTAINMENT;
/
ALTER TRIGGER "SYSTEM"."TGR_COMMON_ENTERTAINMENT" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_COMMON_FEEDBACK
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_COMMON_FEEDBACK" 
　　
    before insert on COMMON_FEEDBACK
    
    for each row
    
    begin
    
    select SEQ_FEEDBACK_ID.nextval into :new.RECORD_ID from dual;
    
   end TGR_COMMON_FEEDBACK;
/
ALTER TRIGGER "SYSTEM"."TGR_COMMON_FEEDBACK" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_COMMON_USER
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_COMMON_USER" 
　　
    before insert on COMMON_USER
    
    for each row
    
    begin
    
    select SEQ_USER_ID.nextval into :new.RECORD_ID from dual;
    
    end TGR_COMMON_USER;
/
ALTER TRIGGER "SYSTEM"."TGR_COMMON_USER" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_ENTERTAINMENT_COMMENT
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_ENTERTAINMENT_COMMENT" 
　　
    before insert on COMMON_ENTERTAINMENT_COMMENT
    
    for each row
    
    begin
    
    select SEQ_ENTERTAINMENT_COMMENT_ID.nextval into :new.RECORD_ID from dual;
    
   end tgr_entertainment_comment;
/
ALTER TRIGGER "SYSTEM"."TGR_ENTERTAINMENT_COMMENT" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_ENTERTAINMENT_REPRINT
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_ENTERTAINMENT_REPRINT" 
before INSERT on common_entertainment_reprint 
for each row 
begin
  select SEQ_ENTERTAINMENT_REPRINT_ID.NEXTVAL INTO :NEW.RECORD_ID FROM DUAL;
end tgr_entertainment_reprint;
/
ALTER TRIGGER "SYSTEM"."TGR_ENTERTAINMENT_REPRINT" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_HOT_SEARCH_ID
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_HOT_SEARCH_ID" 
BEFORE INSERT ON COMMON_HOT_SEARCH
FOR EACH ROW 
BEGIN

  SELECT SEQ_HOT_SEARCH_ID.NEXTVAL INTO :NEW.RECORD_ID FROM DUAL;
  
END TGR_HOT_SEARCH_ID;
/
ALTER TRIGGER "SYSTEM"."TGR_HOT_SEARCH_ID" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_INSERT_INCREMENT_ID
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_INSERT_INCREMENT_ID" 
before insert on MOBILE_ADVERTISMENT
for each row

begin
  select SEQ_ADVERTISMENT_ID.nextval into :new.ADVID from dual;
end tgr_insert_increment_id;
/
ALTER TRIGGER "SYSTEM"."TGR_INSERT_INCREMENT_ID" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_INSERT_MESSAGE_STATUS
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_INSERT_MESSAGE_STATUS" 
BEFORE INSERT ON COMMON_MESSAGE_STATUS 
FOR EACH ROW 
BEGIN
  SELECT SEQ_MESSAGE_STATUS_ID.NEXTVAL INTO :NEW.RECORD_ID FROM DUAL;
END TGR_INSERT_MESSAGE_STATUS;
/
ALTER TRIGGER "SYSTEM"."TGR_INSERT_MESSAGE_STATUS" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_PARTTIME_JOB
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_PARTTIME_JOB" 
　　
    before insert on MOBILE_PART_TIME_JOB
    
    for each row
    
    begin
    
    select SEQ_PARTTIME_JOB.nextval into :new.PARTIME_JOB_ID from dual;
    
    end TGR_PARTTIME_JOB;
/
ALTER TRIGGER "SYSTEM"."TGR_PARTTIME_JOB" ENABLE;
--------------------------------------------------------
--  DDL for Trigger TGR_T_ADVERTISMENT_TYPE_ID
--------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SYSTEM"."TGR_T_ADVERTISMENT_TYPE_ID" 
before insert on MOBILE_ADVIRTISMENT_TYPE
for each row 
begin
  select SEQ_ADVERTISMENT_TYPE_ID.nextval into :new.TYPE_ID from dual; 
end tgr_t_advertisment_type_id;
/
ALTER TRIGGER "SYSTEM"."TGR_T_ADVERTISMENT_TYPE_ID" ENABLE;
